With the Word & Excel Study Pack you get two guides in one and everything needed to become proficient in both Word and Excel. In writing this workbook, we have been very careful to make the tutorials as generic as possible, not based on any particular version of Word or Excel. The information contained in this book covers the essence of the applications covered. That is, the topics taught are valid for all versions of both applications. We believe that it is in the interest of our readers to learn the topics that make up the essence of the applications. Version-specific features can always be learnt while using a particular version an application.

Table of Contents EXCEL: -- Windows -- Using the Menu -- Excel Workbooks -- Move the Cell Locator -- Data Entry -- Edit Cell Contents -- Ranges -- Formula Construction -- Relative Cell Referencing -- Copy Command -- Printing -- Cell Alignment -- Numeric Formats -- Format Copying -- Date Formats -- File Management -- Worksheet Management -- Range Names -- Advanced Formulas -- Goal Seek -- Functions -- Protection -- Multiple Sheets -- Link Worksheets -- Charts -- Data Maps -- Export Charts to PowerPoint -- VALIDATE CELL ENTRIES -- LOGICAL FUNCTIONS -- LOOKUP AND REFERENCE FUNCTIONS -- WHAT-IF SCENARIOS -- SOLVER -- VIEWS -- REPORTS -- IMPORT TEXT FILES -- MICROSOFT QUERY -- LIST MANAGEMENT -- FILTERING -- PIVOT TABLES -- OUTLINE WORD: -- WORKING WITH WORD -- MOVING AROUND -- SELECTING TEXT -- EDITING -- MOVE AND COPY -- AUTOMATION -- AutoComplete -- FILING SYSTEMS -- PRINT YOUR WORK -- FORMAT TEXT -- Copy Formatting -- PARAGRAPHS -- Navigation -- Display Paragraph Marks -- Formatting Toolbar -- Set Tabs -- Move a Tab Stop -- Set Tabs -- Text Border -- Page Border -- Automatic Borders -- AutoFit -- Tables and Borders toolbar -- MAIL MERGE -- TABLES -- EMBED EXCEL DATA IN A WORD TABLE -- Work with Styles -- Table of Contents -- Document Templates -- Forms -- Formulas and Calculations -- Fields -- Bookmarks -- Inserting Fields -- Cross Reference -- Office Art -- Text boxes -- objects -- WordArt -- Online text fonts -- Formatting Toolbar -- Tables on Web pages -- Table Properties -- Cell Properties -- AutoLoad a Page

 

Microsoft Word & Excel Study Pack by Rudy LeCorps
Continue Browsing		View Wish List